import openpyxl as vb

path = '../文件/读取数据.xlsx'
wb = vb.load_workbook(path)
wt = wb['Sheet1']

# wt.insert_cols(idx=2, amount=5) #插入列
wt.insert_rows(idx=2, amount=5)  # 插入行

wt.delete_rows(idx=2, amount=5)  # 删除行
wt.delete_cols(idx=2, amount=5)  # 删除列

wb.save(path)
